﻿CREATE TABLE [dbo].[Refeicoes] (
    [IdRefeicaoContratada] BIGINT          NOT NULL,
    [DataRefeicao]         DATE            NOT NULL,
    [TotalVendasPrevisto]  DECIMAL (18, 5) NULL,
    [TotalCustosPrevisto]  DECIMAL (18, 5) NULL,
    [TotalVendasEfectivo]  DECIMAL (18, 5) NULL,
    [TotalCustosEfectivo]  DECIMAL (18, 5) NULL,
    [RacioMPrimasPrevisto] DECIMAL (18, 5) NULL,
    [RacioMPrimasEfectivo] DECIMAL (18, 5) NULL,
    [DataCriacao]          DATETIME        NOT NULL,
    [DataAlteracao]        DATETIME        NOT NULL
);

